1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 //-hiển thị all text trong rows
12 //--https://stackoverflow.com/questions/1706454/c-multiline-text-in-datagridview-control
13
14 namespace SoftQuanLyNhaHang.Views
15 {
16 public delegate void LinkDanhSach_KiemKho_EventHandler(object sender, EventArgs e);
17
18 public delegate void LinkChiTietSanPham_EventHandler(object sender, EventArgs e, int idKho);
19
20 public delegate void Link_DsachTonKho_EventHandler(object sender, EventArgs e);
21
22
23 public partial class uctKho : UserControl
24 {
25 public uctKho()
26 {
27 InitializeComponent();
28 }
29
30 public static uctKho uctK = new uctKho();
31
32 public event LinkDanhSach_KiemKho_EventHandler Link_DanhSach_KiemKho;
33
34 public event LinkChiTietSanPham_EventHandler Link_ChiTietSanPham;
35
36 public event Link_DsachTonKho_EventHandler Link_DsachTonKho;
37
38 int _IdKho = 0;
39
40 int _NhomSanPhamId = 0;
41
42 int _DanhMucId=0;
43 int _getSearchIdNhaCungCap = 0;
44
45 int _NhapHangId = 0;
46 string _AnhDaiDien = string.Empty;
47 int _HanMucDatHang = 0;
48 string _HanSuDung = string.Empty;
49 string _NgaySanXuat = string.Empty;
50 DateTime _NgayHetHan = DateTime.Now;
51
52 //
53 string _MoTa = string.Empty;
54 double _GiaNhap = 0;
55 double _SoLuong = 0;
56 double _Thue = 0;
57 double _ChietKhauPhanTram = 0;
58 double _TiLeLoiNhuan = 0;
59 double _GiaBanLe = 0;
60 double _GiaBanBuon = 0;
61 double _GiaKhuyenMai = 0;
62 DateTime _NgayBatDauGiamGia = DateTime.Now;
63 DateTime _NgayKetThuc = DateTime.Now;
64 string _TrangThai = "SuDung";
65 DateTime _NgayTao = DateTime.Now;
66 string _ChietKhauTheo = "PhanTram";
67 double _TienThue = 0;
68 double _TienChietKhau = 0;
69 int _pageSize = 30;
70 int _pageIndex = 1;
71 int _tongSoBanGhi = 0;
72 int _stt = 0;
73
74 string _MaSanPham = string.Empty;
75 string _MaVietTat = string.Empty;
76 string _TenSanPham= string.Empty;
77 int _NhaCungCapId = 0;
78 int _DonViTinhId =0;
79
80 private void HienThiDonViTinh_ComboBox()
81 {
82 Dictionary<string, string> comboSource = new Dictionary<string, string>();
83 comboSource.Add("0", "-- Chọn đơn vị tính --");
84 DataTable dtdvt = new DataTable();
85 dtdvt = Controllers.DonViTinhCtrl.FillDataSetDonViTinh_GetDanhSach().Tables[0];// Models.NhapKhoMod.FillDataSet_getTenDonViTinh().Tables[0];
86
87 if (dtdvt.Rows.Count > 0)
88 {
89 foreach (DataRow item in dtdvt.Rows)
90 {
91 comboSource.Add(item["IdDonViTinh"].ToString(), item["TenDonViTinh"].ToString());
92 }
93
94 }
95
96 cmbDonViTinh_TimKiem.DataSource = new BindingSource(comboSource, null);
97 cmbDonViTinh_TimKiem.DisplayMember = "Value";
98 cmbDonViTinh_TimKiem.ValueMember = "Key";
99 }
100
101 /*
102 private void HienThi_NhaCungCap_ComboBox()
103 {
104 Dictionary<string, string> comboSource = new Dictionary<string, string>();
105 comboSource.Add("0", "-- Tất cả --");
106 comboSource.Add("01", "-- Tìm --");
107 //DataTable dtdvt = new DataTable();
108 //dtdvt = Controllers.DonViTinhCtrl.FillDataSetDonViTinh_GetDanhSach().Tables[0];// Models.NhapKhoMod.FillDataSet_getTenDonViTinh().Tables[0];
109
110 //if (dtdvt.Rows.Count > 0)
111 //{
112 //foreach (DataRow item in dtdvt.Rows)
113 //{
114 // comboSource.Add(item["IdDonViTinh"].ToString(), item["TenDonViTinh"].ToString());
115 //}
116
117 //}
118
119 cmbNhaCungCap_TimKiem.DataSource = new BindingSource(comboSource, null);
120 cmbNhaCungCap_TimKiem.DisplayMember = "Value";
121 cmbNhaCungCap_TimKiem.ValueMember = "Key";
122 }
123
124 */
125
126 private void uctKho_Load(object sender, EventArgs e)
127 {
128 this.HienThiDonViTinh_ComboBox();
129 //this.HienThi_NhaCungCap_ComboBox();
130
131 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
132 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
133 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
134 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
135
136 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
137 }
138
139
140 //danh sach thiet lap gia
141 private void HienThiDanhSach_HangTrongKho(string maSanPham, string tenSanPham, int nhaCungCapId, int donViTinhId)
142 {
143 dgvDanhSachKho.Rows.Clear();
144 //Ẩn cột đầu tiên
145 dgvDanhSachKho.RowHeadersVisible = false;
146 //-https://stackoverflow.com/questions/17404969/right-align-a-column-in-datagridview-doesnt-work
147 this.dgvDanhSachKho.Columns["STT"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
148 this.dgvDanhSachKho.Columns["STT"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
149 //this.dgvDanhSachNhapHang.Columns["STT"].SortMode = DataGridViewColumnSortMode.NotSortable;
150
151 this.dgvDanhSachKho.Columns["SoLuong"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
152 this.dgvDanhSachKho.Columns["SoLuong"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
153
154 this.dgvDanhSachKho.Columns["SoLuongDaBan"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
155 this.dgvDanhSachKho.Columns["SoLuongDaBan"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
156
157 this.dgvDanhSachKho.Columns["SoLuongTrongKho"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
158 this.dgvDanhSachKho.Columns["SoLuongTrongKho"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
159
160 this.dgvDanhSachKho.Columns["Thue"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
161 this.dgvDanhSachKho.Columns["Thue"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
162
163 this.dgvDanhSachKho.Columns["ChietKhauPhanTram"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
164 this.dgvDanhSachKho.Columns["ChietKhauPhanTram"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
165
166 this.dgvDanhSachKho.Columns["GiaBanLe"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
167 this.dgvDanhSachKho.Columns["GiaBanLe"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
168
169 this.dgvDanhSachKho.Columns["GiaNhap"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
170 this.dgvDanhSachKho.Columns["GiaNhap"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
171
172 this.dgvDanhSachKho.Columns["TenDonViTinh"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
173 this.dgvDanhSachKho.Columns["TenDonViTinh"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
174
175 this.dgvDanhSachKho.Columns["TiLeLoiNhuan"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
176 this.dgvDanhSachKho.Columns["TiLeLoiNhuan"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
177
178 this.dgvDanhSachKho.Columns["NgayTao"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
179 this.dgvDanhSachKho.Columns["NgayTao"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
180
181 this.dgvDanhSachKho.Columns["ThueSuat"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
182 this.dgvDanhSachKho.Columns["ThueSuat"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
183
184 this.dgvDanhSachKho.Columns["CKSuat"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
185 this.dgvDanhSachKho.Columns["CKSuat"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
186
187 this.dgvDanhSachKho.Columns["HanSuDung"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
188 this.dgvDanhSachKho.Columns["HanSuDung"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
189
190
191 DataTable dtDsKho = new DataTable();
192
193 dtDsKho = Controllers.KhoCtrl.FillDataSet_getKho_AllSearch(_IdKho, maSanPham, tenSanPham, _NhomSanPhamId, donViTinhId, _DanhMucId, nhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _pageSize, _pageIndex).Tables[0];
194 //dtDsKho = Controllers.KhoCtrl.FillDataSet_getKho_AllSearch_ByHaving(_IdKho, maSanPham, tenSanPham, _NhomSanPhamId, donViTinhId, _DanhMucId, nhaCungCapId, _NhapHangId, _AnhDaiDien, _HanMucDatHang, _HanSuDung, _NgaySanXuat, _NgayHetHan, _MoTa, _GiaNhap, _SoLuong, _Thue, _ChietKhauPhanTram, _TiLeLoiNhuan, _GiaBanLe, _GiaBanBuon, _GiaKhuyenMai, _NgayBatDauGiamGia, _NgayKetThuc, _TrangThai, _NgayTao, _ChietKhauTheo, _TienThue, _TienChietKhau, _pageSize, _pageIndex).Tables[0];
195 //dtKho = Controllers.KhoCtrl.FillDataSet_getKho_AllSearch(_IdKho, _MaSanPham, _TenSanPham, 0, 0, 0, _NhaCungCapId, 0, "anhdaidien", 0, "hansudung", "ngaysanxuat", DateTime.Now, "MoTa", 0, 0, 0, 0, 0, 0, 0, 0, DateTime.Now, DateTime.Now, "trangthai", DateTime.Now, "Chietkhautheo", 0, 0, _pageSize, _pageIndex).Tables[0];
196
197 if (dtDsKho.Rows.Count > 0)
198 {
199 _tongSoBanGhi = Int32.Parse(dtDsKho.Rows[0]["TongSoBanGhi"].ToString());
200
201 double gianhap = 0;
202 double thuenhap = 0;
203 double chietkhaunhap = 0;
204 double gianhap_CoThueVaCk = 0;
205 float soluongNhap = 0;
206 float soluongDaBan = 0;
207 float soluongTrongKho = 0;
208 //double tienchietkhaunhap = 0;
209 //double tienthuenhap = 0;
210
211 //double gianhapAll = 0;
212
213 double giabanle = 0;
214 double thuebanhang = 0;
215 double chietkhaubanhang = 0;
216 double giabanle_TinhCkVaThue = 0;
217
218 //double giabanbuon = 0;
219 double tileloinhuan = 0;
220
221 foreach (DataRow item in dtDsKho.Rows)
222 {
223 _stt += 1;
224 int nthue = dgvDanhSachKho.Rows.Add();
225
226 dgvDanhSachKho.Rows[nthue].Cells["IdKho"].Value = item["IdKho"].ToString();
227
228 dgvDanhSachKho.Rows[nthue].Cells["STT"].Value = _stt.ToString();
229
230 dgvDanhSachKho.Rows[nthue].Cells["MaSanPham"].Value = item["MaSanPham"].ToString();
231 dgvDanhSachKho.Rows[nthue].Cells["MaVietTat"].Value = item["MaVietTat"].ToString();
232 dgvDanhSachKho.Rows[nthue].Cells["TenSanPham"].Value = item["TenSanPham"].ToString();
233 dgvDanhSachKho.Rows[nthue].Cells["NhaCungCap"].Value = item["HoVaTen"].ToString();
234 dgvDanhSachKho.Rows[nthue].Cells["TenDonViTinh"].Value = item["TenDonViTinh"].ToString();
235
236 gianhap = CauHinhHeThong.Format_SoDeTinhToan(item["GiaNhap"].ToString(),false);
237 thuenhap = CauHinhHeThong.Format_SoDeTinhToan(item["Thue"].ToString(), false);
238 chietkhaunhap = CauHinhHeThong.Format_SoDeTinhToan(item["ChietKhauPhanTram"].ToString(), false);
239
240 dgvDanhSachKho.Rows[nthue].Cells["Thue"].Value = CauHinhHeThong.Format_SoDeHienThi(thuenhap, false);
241 dgvDanhSachKho.Rows[nthue].Cells["ChietKhauPhanTram"].Value = CauHinhHeThong.Format_SoDeHienThi(chietkhaunhap, false);
242
243
244 soluongNhap = (float)CauHinhHeThong.Format_SoDeTinhToan(item["SoLuong"].ToString(), false);
245 soluongDaBan = (float)CauHinhHeThong.Format_SoDeTinhToan(item["SoLuongDaBan"].ToString(), false);
246
247 soluongTrongKho = (soluongNhap - soluongDaBan);
248
249
250 dgvDanhSachKho.Rows[nthue].Cells["SoLuong"].Value = CauHinhHeThong.Format_SoDeHienThi(soluongNhap, false);
251
252 //dgvDanhSachKho.Rows[nthue].Cells["SoLuongTrongKho"].Value = CauHinhHeThong.Format_SoDeHienThi(soluongTrongKho, false);
253
254 //dgvDanhSachKho.Rows[nthue].Cells["SoLuongDaBan"].Value = CauHinhHeThong.Format_SoDeHienThi(soluongDaBan, false);
255 //tienchietkhaunhap = gianhap * chietkhaunhap / 100;
256 //tienthuenhap = gianhap * thuenhap / 100;
257 //hien thi gia nhap tinh thue va chiet khau
258 //gianhapAll = gianhap + tienthuenhap - tienchietkhaunhap;
259
260 giabanle = CauHinhHeThong.Format_SoDeTinhToan(item["GiaBanLe"].ToString(), false);
261 thuebanhang = CauHinhHeThong.Format_SoDeTinhToan(item["ThueBanHang"].ToString(), false);
262 chietkhaubanhang = CauHinhHeThong.Format_SoDeTinhToan(item["ChietKhauPTBanHang"].ToString(), false);
263
264 //dgvDanhSachKho.Rows[nthue].Cells["ThueSuat"].Value = CauHinhHeThong.Format_SoDeHienThi(thuebanhang, false);
265 //dgvDanhSachKho.Rows[nthue].Cells["CKSuat"].Value = CauHinhHeThong.Format_SoDeHienThi(chietkhaubanhang, false);
266
267 dgvDanhSachKho.Rows[nthue].Cells["GiaNhap"].Value = CauHinhHeThong.Format_SoDeHienThi(gianhap, true);
268
269 if (chkGiaTheoNhieusp.Checked == true)
270 {
271 gianhap_CoThueVaCk = gianhap * soluongNhap + (gianhap * soluongNhap * thuenhap / 100) - (gianhap * soluongNhap * chietkhaunhap / 100);
272 //dgvDanhSachKho.Rows[nthue].Cells["GiaNhap"].Value = CauHinhHeThong.Format_SoDeHienThi(gianhap_CoThueVaCk, true);
273
274 giabanle_TinhCkVaThue = (giabanle * soluongNhap) + (giabanle * soluongNhap * thuebanhang / 100) - (giabanle * soluongNhap * thuebanhang / 100);
275 dgvDanhSachKho.Rows[nthue].Cells["GiaBanLe"].Value = CauHinhHeThong.Format_SoDeHienThi(giabanle_TinhCkVaThue, true);
276
277 }
278 else
279 {
280 gianhap_CoThueVaCk = gianhap + (gianhap * thuenhap / 100) - (gianhap * chietkhaunhap / 100);
281 //dgvDanhSachKho.Rows[nthue].Cells["GiaNhap"].Value = CauHinhHeThong.Format_SoDeHienThi(gianhap_CoThueVaCk, true);
282
283 //1 san pham
284 giabanle_TinhCkVaThue = (giabanle * 1) + (giabanle * 1 * thuebanhang / 100) - (giabanle * 1 * thuebanhang / 100);
285 dgvDanhSachKho.Rows[nthue].Cells["GiaBanLe"].Value = CauHinhHeThong.Format_SoDeHienThi(giabanle_TinhCkVaThue, true);
286 }
287
288 if (gianhap_CoThueVaCk == 0)
289 {
290 tileloinhuan = 0;
291 }
292 else
293 {
294 tileloinhuan = ((giabanle_TinhCkVaThue - gianhap_CoThueVaCk) / gianhap_CoThueVaCk) * 100;
295 }
296
297
298
299 dgvDanhSachKho.Rows[nthue].Cells["TiLeLoiNhuan"].Value = CauHinhHeThong.Format_SoDeHienThi(tileloinhuan, false);
300
301 //dgvDanhSachKho.Rows[nthue].Cells["GiaNhap"].Value = CauHinhHeThong.Format_SoDeHienThi(gianhap, true);// item["GiaNhap"].ToString();
302 //dgvDanhSachKho.Rows[nthue].Cells["Thue"].Value = item["Thue"].ToString();
303 //dgvDanhSachKho.Rows[nthue].Cells["ChietKhau"].Value = item["ChietKhauPhanTram"].ToString();
304 //giabanbuon = CauHinhHeThong.Format_SoDeTinhToan(item["GiaBanBuon"].ToString());
305 //dgvDanhSachKho.Rows[nthue].Cells["GiaBanLe"].Value = CauHinhHeThong.Format_SoDeHienThi(giabanle, true);
306 // dgvDanhSachKho.Rows[nthue].Cells["GiaBanBuon"].Value = CauHinhHeThong.Format_SoDeHienThi(giabanbuon, true);
307 //dgvDanhSachKho.Rows[nthue].Cells["GiaKhuyenMai"].Value = item["GiaKhuyenMai"].ToString();
308 dgvDanhSachKho.Rows[nthue].Cells["NgayTao"].Value = CauHinhHeThong.Format_HienThiNgayThangNam(item["NgayTao"].ToString(), false);
309
310 if (string.IsNullOrEmpty(item["HanSuDung"].ToString()))
311 {
312 dgvDanhSachKho.Rows[nthue].Cells["HanSuDung"].Value = "?";
313 }
314 else
315 {
316 dgvDanhSachKho.Rows[nthue].Cells["HanSuDung"].Value = item["HanSuDung"].ToString();
317 }
318
319 }
320 }
321 else
322 {
323 _tongSoBanGhi = 0;
324 }
325
326 lblTongSoBanGhiHienThi.Text = CauHinhHeThong.HienThiSoBanGhiTuA_DenB(_pageSize, _pageIndex, _stt.ToString(), _tongSoBanGhi.ToString());
327 }
328
329
330
331 private void dgvDanhSachKho_CellClick(object sender, DataGridViewCellEventArgs e)
332 {
333 //click vào tên sản phẩm thay đổi mã sản phẩm hoặc mã viết tắt
334 //-https://stackoverflow.com/questions/1132471/how-to-reference-column-name-instead-of-e-columnindex-in-winform-datagridview-ev
335 if ((dgvDanhSachKho.Columns[e.ColumnIndex].Name == "TenSanPham") && e.RowIndex != -1)
336 {
337 //-https://stackoverflow.com/questions/12762036/datagridview-cell-click-event
338 if (dgvDanhSachKho.CurrentCell != null && dgvDanhSachKho.CurrentCell.Value != null)
339 {
340 //cho click vao kho check thay doi thong tin
341 if (ckbThayDoiMaSanPham.Checked == false)
342 {
343 return;
344 }
345
346 string tenSanPham = dgvDanhSachKho.Rows[e.RowIndex].Cells["TenSanPham"].Value.ToString();
347 string maSanPham = dgvDanhSachKho.Rows[e.RowIndex].Cells["MaSanPham"].Value.ToString();
348 string maVietTat = dgvDanhSachKho.Rows[e.RowIndex].Cells["MaVietTat"].Value.ToString();
349 double SLuong = CauHinhHeThong.Format_SoDeTinhToan(dgvDanhSachKho.Rows[e.RowIndex].Cells["SoLuong"].Value.ToString(),true);
350
351
352 frmKho_MvtMsp frmMvtM = new frmKho_MvtMsp(tenSanPham, maSanPham, maVietTat, SLuong);
353 frmMvtM.ShowDialog();
354
355 //_MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
356 //_TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
357 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
358 //_DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
359
360 //this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
361
362 }
363 }
364
365
366 //-https://stackoverflow.com/questions/1132471/how-to-reference-column-name-instead-of-e-columnindex-in-winform-datagridview-ev
367 //if ((dgvDanhSachKho.Columns[e.ColumnIndex].Name == "GiaNhap" || dgvDanhSachKho.Columns[e.ColumnIndex].Name == "GiaBanLe" || dgvDanhSachKho.Columns[e.ColumnIndex].Name == "GiaBanBuon") && e.RowIndex != -1)
368 if ((dgvDanhSachKho.Columns[e.ColumnIndex].Name == "GiaBanLe") && e.RowIndex != -1)
369 {
370 //-https://stackoverflow.com/questions/12762036/datagridview-cell-click-event
371 if (dgvDanhSachKho.CurrentCell != null && dgvDanhSachKho.CurrentCell.Value != null)
372 {
373 //khong cho click vao thay doi thong tin thiet lap gia
374 if (ckbThietLapGia.Checked == false)
375 {
376 return;
377 }
378
379 //_IdKho = 0;//
380 _IdKho = Int32.Parse(dgvDanhSachKho.Rows[e.RowIndex].Cells["IdKho"].Value.ToString());
381 _MaSanPham = dgvDanhSachKho.Rows[e.RowIndex].Cells["MaSanPham"].Value.ToString();
382 _MaVietTat = dgvDanhSachKho.Rows[e.RowIndex].Cells["MaVietTat"].Value.ToString();
383
384 //this.TextboxShowText(_IdKho);
385 frmKho_ThietLapGia frmkho = new frmKho_ThietLapGia(_IdKho, _MaSanPham, _MaVietTat );
386 frmkho.ShowDialog();
387
388 _pageSize = 30;
389 _pageIndex = 1;
390 _stt = 0;
391
392 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
393 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
394 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
395 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
396
397 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
398
399 }
400 }
401
402 //han su dung
403 if (dgvDanhSachKho.Columns[e.ColumnIndex].Name == "HanSuDung" && e.RowIndex != -1)
404 {
405 //-https://stackoverflow.com/questions/12762036/datagridview-cell-click-event
406 if (dgvDanhSachKho.CurrentCell != null && dgvDanhSachKho.CurrentCell.Value != null)
407 {
408 int idKho = 0;
409 idKho = Int32.Parse(dgvDanhSachKho.Rows[e.RowIndex].Cells["IdKho"].Value.ToString());
410
411 if (this.Link_ChiTietSanPham != null)
412 {
413 this.Link_ChiTietSanPham(sender, e, idKho);
414 }
415 }
416 }
417 }
418
419 private void txtTenSanPham_TimKiem_TextChanged(object sender, EventArgs e)
420 {
421 _pageSize = 30;
422 _pageIndex = 1;
423 _stt = 0;
424
425 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
426 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
427 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
428 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
429
430 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
431 }
432
433 /*
434 _pageSize = 30;
435 _pageIndex = 1;
436 _stt = 0;
437
438 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
439 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
440 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
441
442 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _getSearchIdNhaCungCap, _DonViTinhId);
443 */
444 private void txtMaSanPhamOrMaVietTat_TimKiem_TextChanged(object sender, EventArgs e)
445 {
446
447 }
448
449 private void linkLabel_NhaCungCap_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
450 {
451 frmNhaCungCap frmNcc = new frmNhaCungCap();
452
453 //Hiển thị thông tin nhà cung cấp sau khi chọn trong dgv danh sách ncc
454 frmNcc.ChonNhaCungCap = new frmNhaCungCap.GetThongTinNCC(GetValue_ThongTinNCC);
455
456 frmNcc.ShowDialog();
457
458
459 }
460
461 private void cmbDonViTinh_TimKiem_SelectionChangeCommitted(object sender, EventArgs e)
462 {
463 _pageSize = 30;
464 _pageIndex = 1;
465 _stt = 0;
466
467 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
468 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
469 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
470 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
471
472 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
473 }
474
475 /*
476 private void TextboxShowText(int IdKho)
477 {
478
479 DataTable dtK = new DataTable();
480
481 dtK = Controllers.KhoCtrl.FillDataSet_getKho_ByIdKho(IdKho).Tables[0];
482
483 if (dtK.Rows.Count > 0)
484 {
485 foreach (DataRow item in dtK.Rows)
486 {
487 _IdKho = Int32.Parse( item["IdKho"].ToString());
488
489 //txtMaSanPham.Text = item["MaSanPham"].ToString();
490 //txtTenSanPham.Text = item["TenSanPham"].ToString();
491 }
492
493 }
494
495 }
496 */
497
498 private void GetValue_ThongTinNCC(int idNhaCungCap, string hoVaTen, string soDienThoai, string diaChi, bool btnTrangThai)
499 {
500 if (btnTrangThai == true)
501 {
502 _getSearchIdNhaCungCap = idNhaCungCap;
503
504 _pageSize = 30;
505 _pageIndex = 1;
506 _stt = 0;
507
508 grbNCC.Visible = true;
509 txtHoTenNCC.Text = hoVaTen + " " + soDienThoai ;
510
511 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
512 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
513 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
514
515 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _getSearchIdNhaCungCap, _DonViTinhId);
516 }
517 }
518
519 private void linkLabel_TatCaNCC_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
520 {
521
522 grbNCC.Visible = false;
523 _getSearchIdNhaCungCap = 0;
524
525 _pageSize = 30;
526 _pageIndex = 1;
527 _stt = 0;
528
529 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
530 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
531 //_NhaCungCapId = 0;
532 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
533
534 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _getSearchIdNhaCungCap, _DonViTinhId);
535
536 //grbNCC.Visible = false;
537 //linkLabel_TatCaNCC.Visible = true;
538
539 }
540
541 private void linkLabel_XuatExcel_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
542 {
543 frmKho_XuatExcel frmK_XuatE = new frmKho_XuatExcel();
544
545 frmK_XuatE.ShowDialog();
546 }
547
548 private void chkGiaTheoNhieusp_CheckedChanged(object sender, EventArgs e)
549 {
550 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
551 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
552 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
553 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
554
555 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
556 }
557
558 private void linkLabel_Menu_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
559 {
560 if (this.Link_DanhSach_KiemKho != null)
561 {
562 this.Link_DanhSach_KiemKho(sender, e);
563 }
564 }
565
566 private void btnTiep_Click(object sender, EventArgs e)
567 {
568 if (_tongSoBanGhi > (_pageSize * _pageIndex))
569 {
570 _pageIndex = _pageIndex + 1;
571
572 //goi lai ds
573 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
574 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
575 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
576 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
577
578 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
579
580 }
581 else
582 {
583 return;
584 }
585 }
586
587 private void btnSau_Click(object sender, EventArgs e)
588 {
589 if ((_pageSize * _pageIndex) > _pageSize)
590 {
591 _pageIndex = _pageIndex - 1;
592 _stt = _pageSize * _pageIndex - _pageSize;
593
594 //goi lai ds
595 //goi lai ds
596 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
597 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
598 //_NhaCungCapId = Int32.Parse(cmbNhaCungCap_TimKiem.SelectedValue.ToString());
599 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
600
601 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
602
603 }
604 else
605 {
606 _pageIndex = 1;
607 }
608 }
609
610 private void linkLabel_DsachTonKho_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
611 {
612 if (this.Link_DsachTonKho != null)
613 {
614 this.Link_DsachTonKho(sender, e);
615 }
616 }
617
618
619
620 /*
621 private void cmbNhaCungCap_TimKiem_SelectionChangeCommitted(object sender, EventArgs e)
622 {
623 if (cmbNhaCungCap_TimKiem.SelectedValue.ToString() == "01")
624 {
625 frmNhaCungCap frmNcc = new frmNhaCungCap();
626
627 //Hiển thị thông tin nhà cung cấp sau khi chọn trong dgv danh sách ncc
628 frmNcc.ChonNhaCungCap = new frmNhaCungCap.GetThongTinNCC(GetValue_ThongTinNCC);
629
630 frmNcc.ShowDialog();
631 }
632 }
633 */
634
635 public void HienThiLaiDsKho()
636 {
637 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _NhaCungCapId, _DonViTinhId);
638 }
639
640 private void txtMaSanPhamOrMaVietTat_TimKiem_KeyDown(object sender, KeyEventArgs e)
641 {
642 if (e.KeyCode == Keys.Enter)
643 {
644 e.SuppressKeyPress = true;
645 _pageSize = 30;
646 _pageIndex = 1;
647 _stt = 0;
648
649 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
650 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
651 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
652
653 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _getSearchIdNhaCungCap, _DonViTinhId);
654 }
655 }
656
657 private void btnTimKiem_Click(object sender, EventArgs e)
658 {
659 _pageSize = 30;
660 _pageIndex = 1;
661 _stt = 0;
662
663 _MaSanPham = txtMaSanPhamOrMaVietTat_TimKiem.Text.Trim();
664 _TenSanPham = txtTenSanPham_TimKiem.Text.Trim();
665 _DonViTinhId = Int32.Parse(cmbDonViTinh_TimKiem.SelectedValue.ToString());
666
667 this.HienThiDanhSach_HangTrongKho(_MaSanPham, _TenSanPham, _getSearchIdNhaCungCap, _DonViTinhId);
668 }
669 }
670 }